Neo4j Query Results

Query 1: [Execution time: 0.103000 seconds]

Retrieve the total number of matches for each competition and rename the column as 'NumberOfGames'.

Number of Records: 43

Query 2: [Execution time: 0.043001 seconds]

Retrieve all players from a specific club, FC Barcelona.

Number of Records: 62

Query 3: [Execution time: 2.380999 seconds]

Retrieve all players who have never played in the UEFA Champions League.

Number of Records: 27049

Query 4: [Execution time: 0.767000 seconds]

Count the number of appearances in the history of the database for each player.

Number of Records: 19712

Query 5: [Execution time: 1.154895 seconds]

Compute the total number of goals scored by each player in their career and indicate their playing position.

Number of Records: 19712

Query 6: [Execution time: 0.338001 seconds]

Given a certain club ID, return all the players who have played for that club.

Number of Records: 121

Query 7: [Execution time: 0.474999 seconds]

For every defender, return the total number of red cards in their career history.

Number of Records: 6381

Query 8: [Execution time: 0.057001 seconds]

Return the number of games played by each club in the UEFA Champions League.

Number of Records: 68

Query 9: [Execution time: 0.070999 seconds]

Return the number of appearances made by Lionel Messi in the UEFA Champions League.

Number of Records: 1

Query 10: [Execution time: 0.201000 seconds]

For each player, return the number of appearances in the UEFA Champions League along with the club they played for in those matches, ordered by player name and appearances.

Number of Records: 3024

Query 11: [Execution time: 3.187162 seconds]

Return the top 10 players who scored the most goals when they were under 21 years old.

Number of Records: 10

Query 12: [Execution time: 0.506999 seconds]

Return details of all games in a specific competition (Serie A) including game ID, home and away clubs, score, and date.

Number of Records: 4200

Query 13: [Execution time: 0.485001 seconds]

Return the top scorer for the top 5 competitions.

Number of Records: 5

Query 14: [Execution time: 1.660915 seconds]

Return the best striker for each club.

Number of Records: 412

Query 15: [Execution time: 0.120998 seconds]

Find clubs with the most goals scored in away matches.

Number of Records: 10

Query 16: [Execution time: 2.989000 seconds]

Find the 10 most loyal players to clubs (players who have played the most seasons with the same club compared to others).

Number of Records: 10

Query 17: [Execution time: 0.163000 seconds]

Find the best defenses for each competition.

Number of Records: 10

Query 18: [Execution time: 9.713495 seconds]

Find pairs of different players who have played together most frequently in the same games.

Number of Records: 10

Query 19: [Execution time: 12.968007 seconds]

Find pairs of different players who have played against each other most frequently.

Number of Records: 10

Query 20: [Execution time: 0.063001 seconds]

Find the oldest active players in each playing position.

Number of Records: 386